WITH REVENUE0 AS (SELECT L_SUPPKEY AS SUPPLIER_NO,                          SUM(L_EXTENDEDPRICE*(1-L_DISCOUNT)) AS TOTAL_REVENUE                  FROM LINEITEM                  WHERE L_SHIPDATE >= '1996-01-01'                   GROUP BY L_SUPPKEY) SELECT S_SUPPKEY, S_NAME, S_ADDRESS, S_PHONE, TOTAL_REVENUE FROM SUPPLIER, REVENUE0 WHERE S_SUPPKEY = SUPPLIER_NO AND TOTAL_REVENUE = (SELECT MAX(TOTAL_REVENUE)                                                    FROM REVENUE0) ORDER BY S_SUPPKEY;
